INSERT INTO users(userNick, userPass) VALUES('ch1ch3', 'admin');
INSERT INTO users(userNick, userPass) VALUES('luca5', 'admin');
INSERT INTO users(userNick, userPass) VALUES('jed1', 'admin');
INSERT INTO users(userNick, userPass) VALUES('lu1s', 'admin');
INSERT INTO users(userNick, userPass) VALUES('jurg3n', 'admin');
INSERT INTO users(userNick, userPass) VALUES('p3lad0', 'admin');
INSERT INTO surveys(survId, survName, survActive, survUserNick) VALUES(1, 'Employee Evaluation', true, 'ch1ch3');
INSERT INTO surveys(survId, survName, survActive, survUserNick) VALUES(2, 'Employee Benefits', true, 'luca5');
INSERT INTO surveys(survId, survName, survActive, survUserNick) VALUES(3, 'Employee Performance', true, 'jurg3n');
INSERT INTO questions(questId, questText, questSurvId)VALUES(1, 'How hardworking is your employee?', 1);
INSERT INTO questions(questId, questText, questSurvId)VALUES(2, 'Overall, how effective at his/her job is your employee?', 1);
INSERT INTO questions(questId, questText, questSurvId)VALUES(3, 'How well does your employee work with others employees?', 1);
INSERT INTO questions(questId, questText, questSurvId)VALUES(4, 'How quickly does your employee follow up on requests?', 1);
INSERT INTO questions(questId, questText, questSurvId)VALUES(5, 'How much attention to detail does your employee have?', 1);
INSERT INTO questions(questId, questText, questSurvId)VALUES(6, 'How well does your employee handle criticism of his work?', 1);
INSERT INTO questions(questId, questText, questSurvId)VALUES(7, 'How comfortable is your employees sofa?', 1);
INSERT INTO questions(questId, questText, questSurvId)VALUES(8, 'How comfortable is your employers work environment?', 2);
INSERT INTO questions(questId, questText, questSurvId)VALUES(9, 'Are you satisfied with your options?', 2);
INSERT INTO questions(questId, questText, questSurvId)VALUES(10, 'Is your employers health insurance plan better?', 2);
INSERT INTO questions(questId, questText, questSurvId)VALUES(11, 'Are you satisfied with your employers catered meals?', 2);
INSERT INTO questions(questId, questText, questSurvId)VALUES(12, 'How fair is your employers sick day policy?', 2);
INSERT INTO questions(questId, questText, questSurvId)VALUES(13, 'Are you satisfied with your employee benefits?', 2);
INSERT INTO questions(questId, questText, questSurvId)VALUES(14, 'How available to employees is your supervisor?', 3);
INSERT INTO questions(questId, questText, questSurvId)VALUES(15, 'How often does your supervisor give you feedback?', 3);
INSERT INTO questions(questId, questText, questSurvId)VALUES(16, 'How improved is your performance  after getting feedback?', 3);
INSERT INTO questions(questId, questText, questSurvId)VALUES(17, 'How effective is the training you receive?', 3);
INSERT INTO questions(questId, questText, questSurvId)VALUES(18, 'How consistently does your supervisor reward you?', 3);
INSERT INTO questions(questId, questText, questSurvId)VALUES(19, 'How consistently does your supervisor punish you?', 3);
INSERT INTO questions(questId, questText, questSurvId)VALUES(20, 'How reasonable are the decisions made by your supervisor?', 3);
INSERT INTO answers(answId, answText, answQuestId) VALUES(1, 'Extremely hardworking', 1);
INSERT INTO answers(answId, answText, answQuestId) VALUES(2, 'Quite hardworking', 1);
INSERT INTO answers(answId, answText, answQuestId) VALUES(3, 'Moderately hardworking', 1);
INSERT INTO answers(answId, answText, answQuestId) VALUES(4, 'Extremely effective', 2);
INSERT INTO answers(answId, answText, answQuestId) VALUES(5, 'Quite effective', 2);
INSERT INTO answers(answId, answText, answQuestId) VALUES(6, 'Moderately effective', 2);
INSERT INTO answers(answId, answText, answQuestId) VALUES(7, 'Extremely well', 3);
INSERT INTO answers(answId, answText, answQuestId) VALUES(8, 'Very well', 3);
INSERT INTO answers(answId, answText, answQuestId) VALUES(9, 'Moderately well', 3);
INSERT INTO answers(answId, answText, answQuestId) VALUES(10, 'Extremely quickly', 4);
INSERT INTO answers(answId, answText, answQuestId) VALUES(11, 'quite quickly', 4);
INSERT INTO answers(answId, answText, answQuestId) VALUES(12, 'Moderately quickly', 4);
INSERT INTO answers(answId, answText, answQuestId) VALUES(13, 'A great deal of attention', 5);
INSERT INTO answers(answId, answText, answQuestId) VALUES(14, 'a lot of attention', 5);
INSERT INTO answers(answId, answText, answQuestId) VALUES(15, 'A moderate amount of attention', 5);
INSERT INTO answers(answId, answText, answQuestId) VALUES(16, 'Extremely quickly', 6);
INSERT INTO answers(answId, answText, answQuestId) VALUES(17, 'Quite quickly', 6);
INSERT INTO answers(answId, answText, answQuestId) VALUES(18, 'Moderately quickly', 6);
INSERT INTO answers(answId, answText, answQuestId) VALUES(19, 'Extremely well', 7);
INSERT INTO answers(answId, answText, answQuestId) VALUES(20, 'Very well', 7);
INSERT INTO answers(answId, answText, answQuestId) VALUES(21, 'Not very well', 7);
INSERT INTO answers(answId, answText, answQuestId) VALUES(23, 'Extremely comfortable', 8);
INSERT INTO answers(answId, answText, answQuestId) VALUES(24, 'Quite comfortable', 8);
INSERT INTO answers(answId, answText, answQuestId) VALUES(25, 'Moderately comfortable', 8);
INSERT INTO answers(answId, answText, answQuestId) VALUES(26, 'Extremely satisfied', 9);
INSERT INTO answers(answId, answText, answQuestId) VALUES(27, 'quite satisfied', 9);
INSERT INTO answers(answId, answText, answQuestId) VALUES(28, 'Somewhat satisfied', 9);
INSERT INTO answers(answId, answText, answQuestId) VALUES(29, 'Much better', 10);
INSERT INTO answers(answId, answText, answQuestId) VALUES(30, 'Somewhat better', 10);
INSERT INTO answers(answId, answText, answQuestId) VALUES(31, 'Slightly better', 10);
INSERT INTO answers(answId, answText, answQuestId) VALUES(32, 'Extremely satisfied', 11);
INSERT INTO answers(answId, answText, answQuestId) VALUES(33, 'Quite satisfied', 11);
INSERT INTO answers(answId, answText, answQuestId) VALUES(34, 'Slightly satisfied', 11);
INSERT INTO answers(answId, answText, answQuestId) VALUES(36, 'Extremely fair', 12);
INSERT INTO answers(answId, answText, answQuestId) VALUES(37, 'Quite fair', 12);
INSERT INTO answers(answId, answText, answQuestId) VALUES(38, 'Moderately fair', 12);
INSERT INTO answers(answId, answText, answQuestId) VALUES(39, 'Extremely satisfied', 13);
INSERT INTO answers(answId, answText, answQuestId) VALUES(40, 'Quite satisfied', 13);
INSERT INTO answers(answId, answText, answQuestId) VALUES(41, 'Moderately satisfied', 13);
INSERT INTO answers(answId, answText, answQuestId) VALUES(42, 'Extremely available', 14);
INSERT INTO answers(answId, answText, answQuestId) VALUES(43, 'Quite available', 14);
INSERT INTO answers(answId, answText, answQuestId) VALUES(44, 'Moderately available', 14);
INSERT INTO answers(answId, answText, answQuestId) VALUES(45, 'Extremely often', 15);
INSERT INTO answers(answId, answText, answQuestId) VALUES(46, 'Quite often', 15);
INSERT INTO answers(answId, answText, answQuestId) VALUES(47, 'Moderately often', 15);
INSERT INTO answers(answId, answText, answQuestId) VALUES(48, 'Extremely improved', 16);
INSERT INTO answers(answId, answText, answQuestId) VALUES(49, 'Quite improved', 16);
INSERT INTO answers(answId, answText, answQuestId) VALUES(50, 'Moderately improved', 16);
INSERT INTO answers(answId, answText, answQuestId) VALUES(51, 'Extremely effective', 17);
INSERT INTO answers(answId, answText, answQuestId) VALUES(52, 'Quite effective', 17);
INSERT INTO answers(answId, answText, answQuestId) VALUES(53, 'Moderately effective', 17);
INSERT INTO answers(answId, answText, answQuestId) VALUES(54, 'Extemely consistently', 18);
INSERT INTO answers(answId, answText, answQuestId) VALUES(55, 'Quite consistently', 18);
INSERT INTO answers(answId, answText, answQuestId) VALUES(56, 'Moderately consistently', 18);
INSERT INTO answers(answId, answText, answQuestId) VALUES(57, 'Extremely reasonable', 19);
INSERT INTO answers(answId, answText, answQuestId) VALUES(58, 'quite reasonable', 19);
INSERT INTO answers(answId, answText, answQuestId) VALUES(59, 'Moderately reasonable', 19);
INSERT INTO answers(answId, answText, answQuestId) VALUES(60, 'Extremely reasonable', 20);
INSERT INTO answers(answId, answText, answQuestId) VALUES(61, 'Quite reasonable', 20);
INSERT INTO answers(answId, answText, answQuestId) VALUES(62, 'Moderately reasonable', 20);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 1, 1);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 1, 4);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 1, 8);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 1, 11);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 1, 15);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 1, 17);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 1, 20);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('ch1ch3', 2, 25);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('ch1ch3', 2, 27);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('ch1ch3', 2, 29);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('ch1ch3', 2, 33);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('ch1ch3', 2, 37);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('ch1ch3', 2, 40);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jed1', 2, 25);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jed1', 2, 26);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jed1', 2, 30);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jed1', 2, 32);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jed1', 2, 36);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jed1', 2, 40);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 3, 42);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 3, 47);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 3, 49);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 3, 52);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 3, 54);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 3, 58);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 3, 61);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 2, 24);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 2, 26);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 2, 30);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 2, 32);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 2, 37);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('lu1s', 2, 39);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jurg3n', 1, 2);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jurg3n', 1, 5);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jurg3n', 1, 8);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jurg3n', 1, 11);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jurg3n', 1, 14);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jurg3n', 1, 17);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('jurg3n', 1, 20);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('p3lad0', 3, 43);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('p3lad0', 3, 45);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('p3lad0', 3, 49);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('p3lad0', 3, 51);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('p3lad0', 3, 54);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('p3lad0', 3, 58);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('p3lad0', 3, 62);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 3, 43);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 3, 45);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 3, 48);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 3, 52);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 3, 55);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 3, 57);
INSERT INTO users_surveys(us_svUserNick, us_svSurvId, us_svAnswId)VALUES('luca5', 3, 61);